package com.num2.dao.lkw;

import java.util.List;

import org.apache.ibatis.annotations.Select;
import com.num2.model.lkw.BalanceModel;

public interface IBalanceDao {
	//通过username获取user_id
	@Select("select user_id from user_info where user_name = #{user_name}")
	public int selectName(String user_name);
	//通过userid获取余额
	@Select("select balance from transaction_record where transaction_id=(select max(transaction_id) from transaction_record where user_id = #{user_id}) ")
	 List<BalanceModel> select(int user_id);
}
